package dao;

import Utils.db.dao.PageDao;
import Utils.db.pojo.Page;
import pojo.Task;
import pojo.User;

import java.sql.SQLException;
import java.util.List;

public interface UserDAO extends PageDao<User> {

    public User addUser(User user) throws SQLException;

    public Integer deleteUserById(Integer id);

    public Integer deleteUserByUserame(String username);

    public User queryUserByUsernameAndPassword(String username, String password) throws SQLException;

    public User queryUserByUsername(String username) throws SQLException;

    public Integer updateUserById(User user);
    public Integer getEctByUsernameBlur(String username) throws SQLException;

    public List<User> queryUsersByUsernameBlur(String username) throws SQLException;

    public List<User> queryBeanListPerPageByUsernameBlur(Integer eStart, Integer ecp, String username) throws SQLException;

    public User queryById(Integer id) throws SQLException;
}
